package com.lyl.serviceorder.mapper;

import com.lyl.serviceorder.entity.Order;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * <p>
 * 订单 Mapper 接口
 * </p>
 *
 * @author 雷艳玲
 * @since 2022-06-25
 */
public interface OrderMapper extends BaseMapper<Order> {

    @Select("select sum(total_fee) from  t_pay_log where date(pay_time)= #{date} and trade_state='success'")
    double sumPriceByDate(@Param("date") String date);
}
